Learn Excel from MrExcel - Episode 241 - Old Accountant's Trick
Today, I am appearing at the IMA Continuing Education Workshop in Kent Ohio. There will be a few hundred serious accountants in that room with me today, and most of them will know this trick. Today, we have a spreadsheet where someone added manual subtotals to the worksheet. Rather than building a formula to point just to the totals, there is a cool trick that uses a bit of algebra to solve the problem. Episode 241 will show you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!